

***************************************2015年11月5日09:05:24 对个人桌面的案件进展情况统计，添加转接案源列*****************************************************************************************************

	CaseSourceReceiveAction.java
	文件所在包路径：
					  E:\IdeaProjects\natx_backup2\ntax\src\com\ce\cases\source\action\CaseSourceReceiveAction.java

select * from (
				select count(*) from(
									select * from CASE_ASSIT_CHECK t 
													where 	t.VC_DEL$FLAG = 0 
															and register_date>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  
															and register_date<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')  
															order by register_date desc
									)
				) sql_$1 where rownum=1
			
			
select * from (
				select sql_$t.*,rownum sql_$r from (
													select * from CASE_ASSIT_CHECK t 
																where 	t.VC_DEL$FLAG = 0 
																		and register_date>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  
																		and register_date<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')  
																		order by register_date desc
													) sql_$t where rownum<=?
				)where sql_$r>?  [20,0]
				

12:03:06 INFO [SQL] -
select m.vc_name, '查询或查看' as optname,m.vc_id  from sys_t_menu m where m.vc_id = '661903dd76974d1787373b10930f229a' and m.vc_del$flag = 0
查询-协查案源--------------------------------------zl*************************************************
12:03:07 INFO [SQL] - select * from (
										select count(*) from(
																select * from CASE_ASSIT_CHECK t 
																				where 	t.VC_DEL$FLAG = 0 
																						and register_date>=to_date('2015-09-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  
																						and register_date<=to_date('2015-09-11 23:59:59','yyyy-mm-dd hh24:mi:ss')  
																						order by register_date desc
															)
									) sql_$1 where rownum=1  
查询-协查案源--------------------------------------zl*************************************************
12:03:07 INFO [SQL] - 
						select * from (
										select sql_$t.*,rownum sql_$r from (
																			select * 	from CASE_ASSIT_CHECK t 
																						where 	t.VC_DEL$FLAG = 0 
																								and register_date>=to_date('2015-09-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  
																								and register_date<=to_date('2015-09-11 23:59:59','yyyy-mm-dd hh24:mi:ss')  
																								order by register_date desc
																			) sql_$t where rownum<=?
										)where sql_$r>?  [20,0]


***************************************2015年9月23日09:44:16 *****************************************************************************************************

xczh


***************************************2015年11月5日09:05:24 流程监控-第一稽查局.选案列表 查询*****************************************************************************************************

09:04:55 INFO [SQL] - select * from (select cache_version from SYS_T_CACHE$VERSION where cache_name='MENU_CACHE') sql_$1 where rownum=1
09:04:55 INFO [SQL] - select * from (select vc_id from  sys_t_menu t where t.vc_del$flag = 0 and t.int_level =0 and t.vc_url='/ntax/cases/source/CaseSourceSend.action?op=searchjs') sql_$1 where rownum=1
09:04:55 INFO [SQL] - select * from (select vc_id from  sys_t_menu t where t.vc_del$flag = 0 and t.int_level =0 and t.vc_url='/ntax/cases/source/CaseSourceSend.action') sql_$1 where rownum=1
09:04:55 INFO [SQL] - select m.vc_name, '查询或查看' as optname,m.vc_id  from sys_t_menu m where m.vc_id = '6e553a93e550461891032d79924f5c7c' and m.vc_del$flag = 0
1 进来了………………+++++++++++++++++++++++++++SearchAction.execute()2015-11-05 09:04:55
2 +++++++++++++++++++++++++++SearchAction.execute()-true    2015-11-05 09:04:55
3 +++++++++++++++++++++++++++SearchAction.searchDataJs()2015-11-05 09:04:55
Hibernate: select sysvorg0_.VC_ID as VC1_33_0_, sysvorg0_.VC_NUMBER as VC2_33_0_, sysvorg0_.VC_ORG$LEVEL as VC3_33_0_, sysvorg0_.N_SEQ as N4_33_0_, sysvorg0_.VC_NAME as VC5_33_0_, sysvorg0_.VC_TYPE as VC6_33_0_, sysvorg0_.VC_MAN$PRO$TYPE as VC7_33_0_, sysvorg0_.VC_DESC as VC8_33_0_, sysvorg0_.VC_FLAG$LEAF as VC9_33_0_, sysvorg0_.VC_PAR$ORGID as VC10_33_0_, sysvorg0_.VC_PAR$ORG$TYPE$FLAG as VC11_33_0_, sysvorg0_.VC_ORG$TYPE$FLAG as VC12_33_0_, sysvorg0_.N_ID as N13_33_0_, sysvorg0_.VC_PHONE as VC14_33_0_ from SYS_V_ORG$DEP sysvorg0_ where sysvorg0_.VC_ID=?
09:04:55 INFO [SQL] - select * from (select vc_id from (SELECT vc_id,vc_org$level,vc_type,vc_name FROM SYS_V_ORG$DEP t START WITH t.VC_ID ='15009070000' CONNECT BY PRIOR VC_PAR$ORGID=vc_id ORDER BY vc_org$level desc,vc_type ) tt where tt.vc_type='1') sql_$1 where rownum=1
09:04:55 INFO [SQL] - select * from (select vc_org$level from (SELECT vc_id,vc_org$level,vc_type,vc_name FROM SYS_V_ORG$DEP t START WITH t.VC_ID ='15009070000' CONNECT BY PRIOR VC_PAR$ORGID=vc_id ORDER BY vc_org$level desc,vc_type ) tt where tt.vc_type='1') sql_$1 where rownum=1
09:04:55 INFO [SQL] - select * from (select count(*) from(select t.*,hear.ILLEGAL_TYPE_HEAR_NAME,work.DT_DATE downDate,work.VC_STATUS,work.VC_HANDLE_ORGNAME,(select f.VC_STATUS from T_WORKFLOW_FLOW f where f.VC_RECORD_ID=VC_RECORD_ID and f.VC_WORK_ID=work.vc_id and f.VC_SEQUENCE=work.vc_Status) as vcStatus_ from CASE_SOURCE t,case_source_hear hear,T_WORKFLOW_WORK work where t.vc_id=VC_RECORD_ID(+) and t.vc_id=hear.CASE_ID(+) and t.state=3 and t.VC_DEL$FLAG = 0 and (to_number(work.vc_status)<>9 or (to_number(work.vc_status)=9  and work.Dt_DATE>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  and work.Dt_DATE<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') )) and t.inspection_dept_id=? and work.VC_STATUS=? order by work.DT_DATE desc,t.vc_id)) sql_$1 where rownum=1  [15007010000,1]
09:04:55 INFO [SQL] - select * from (select sql_$t.*,rownum sql_$r from (select t.*,hear.ILLEGAL_TYPE_HEAR_NAME,work.DT_DATE downDate,work.VC_STATUS,work.VC_HANDLE_ORGNAME,(select f.VC_STATUS from T_WORKFLOW_FLOW f where f.VC_RECORD_ID=VC_RECORD_ID and f.VC_WORK_ID=work.vc_id and f.VC_SEQUENCE=work.vc_Status) as vcStatus_ from CASE_SOURCE t,case_source_hear hear,T_WORKFLOW_WORK work where t.vc_id=VC_RECORD_ID(+) and t.vc_id=hear.CASE_ID(+) and t.state=3 and t.VC_DEL$FLAG = 0 and (to_number(work.vc_status)<>9 or (to_number(work.vc_status)=9  and work.Dt_DATE>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  and work.Dt_DATE<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') )) and t.inspection_dept_id=? and work.VC_STATUS=? order by work.DT_DATE desc,t.vc_id) sql_$t where rownum<=?) where sql_$r>?  [15007010000,1,20,0]

***************************************2015年11月5日09:05:24 流程监控-第一稽查局.选案列表 查询*****************************************************************************************************


select * from (
                        select  count(work.VC_STATUS) as cnt ,work.vc_status as vc_status

                                                                              from
                                                                                    CASE_SOURCE t,
                                                                                    case_source_hear hear,
                                                                                    T_WORKFLOW_WORK work
                                                                              where
                                                                              t.vc_id=VC_RECORD_ID(+)
                                                                              and t.vc_id=hear.CASE_ID(+)
                                                                              and t.state=3 and t.VC_DEL$FLAG = 0


                                                                              and t.inspection_dept_id=15007010000    --管辖稽查局ID
                                                                              and work.VC_STATUS in('1','-2','2','3','4','9')
                                                                              and (to_number(work.vc_status)<>9 or (to_number(work.vc_status)=9
                                                                                      and work.Dt_DATE>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')  and work.Dt_DATE<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')
                                                                                      ))
                                                                             group by work.vc_status order by work.vc_status
                                                                          )
                                                                          order by work.DT_DATE desc,t.vc_id)
) sql_$1
where rownum=1
[15007010000,1]


select count(*) as cnt,w.vc_status from
				 CASE_SOURCE t,T_WORKFLOW_WORK w
				 where
         t.vc_id=w.VC_RECORD_ID
         and t.vc_del$flag='0'
         and w.vc_status in('1','-2','2','3','4','9')
         and (t.VC_REVOCATION is null or t.VC_REVOCATION=0 or t.VC_REVOCATION=1 or t.VC_REVOCATION=-1)
         and t.INSPECTION_DEPT_ID='15007010000'
         and register_date>=to_date('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and register_date<=to_date('2015-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')
         group by w.vc_status order by w.vc_status

----- 2016年1月19日11:43:34  主页（-2暂存）
select
count(work.VC_STATUS) as cnt ,work.vc_status as vc_status
from
CASE_SOURCE t,
case_source_hear hear,
T_WORKFLOW_WORK work
where
t.vc_id=VC_RECORD_ID(+)
and t.vc_id=hear.CASE_ID(+)
and t.state=3
and t.VC_DEL$FLAG = 0
and t.inspection_dept_id=15007050000
and work.VC_STATUS in('-2')
and work.VC_HANDLE_DATE>=to_date('2016-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
          and work.VC_HANDLE_DATE<=to_date('2016-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')
group by work.vc_status order by work.vc_status



市局合议台账--模块
修改时间 ：2016年5月10日10:42:13


SELECT T1.VC_ID,T1.CASE_NUMBER,T1.INVOLVED_ENTERPRICE AS
ENTERPRICE,T4.REGISTER_DATE AS COMMIT_DATE,T3.END_DATE,T3.MAIN_DISPUTE,T3.PUNISHMENT_DEAL
FROM
CASE_SOURCE T1,
T_WORKFLOW_WORK WORK,
CASE_SOURCE_HEAR T2,
CASE_SOURCE_COLLEGIAL T3,
CASE_SOURCE_COLLEGIAL_DRAW T4
where
T1.VC_DEL$FLAG=0
AND  T1.VC_ID=T2.CASE_ID
AND T1.VC_ID=T3.CASE_ID(+)
AND T1.VC_ID=T4.CASE_ID(+)
AND T2.IS_COLLEGIATE=1
AND T1.VC_ID=WORK.VC_RECORD_ID   --修改查询时间  2016年5月10日10:41:27  周路
AND ((T3.END_DATE>=TO_DATE('2016-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND T3.END_DATE<=TO_DATE('2016-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss'))or T3.COMMIT_DATE IS NULL)

AND (TO_NUMBER(WORK.VC_STATUS)<>9 OR
(TO_NUMBER(WORK.VC_STATUS)=9
AND RECEIVE_DATE>=TO_DATE('2016-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
AND RECEIVE_DATE<=TO_DATE('2016-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss')
)
)




select sysperson0_.VC_ID as VC1_34_, sysperson0_.VC_NUMBER as VC2_34_, sysperson0_.VC_ORG$ID as VC3_34_, sysperson0_.VC_NAME as VC4_34_, sysperson0_.VC_STATUS as VC5_34_, sysperson0_.VC_PID as VC6_34_, sysperson0_.VC_PWD as VC7_34_, sysperson0_.VC_SEX as VC8_34_, sysperson0_.DT_BORN as DT9_34_, sysperson0_.VC_TITLE as VC10_34_, sysperson0_.VC_POSITION as VC11_34_, sysperson0_.VC_TEL as VC12_34_, sysperson0_.VC_MOBILE as VC13_34_, sysperson0_.VC_PHONE as VC14_34_, sysperson0_.VC_NOTE as VC15_34_, sysperson0_.N_ID as N16_34_, sysperson0_.VC_MAIL$NAME as VC17_34_, sysperson0_.VC_WORKTYPE as VC18_34_, sysperson0_.VC_HOME as VC19_34_, sysperson0_.VC_ADDRESS as VC20_34_, sysperson0_.VC_POLITICS as VC21_34_, sysperson0_.VC_JOIN as VC22_34_, sysperson0_.VC_GRADE as VC23_34_, sysperson0_.VC_CRTR as VC24_34_, sysperson0_.VC_CRTRDATE as VC25_34_, sysperson0_.VC_CHIEF$TYPE as VC26_34_, sysperson0_.VC_LAST_NUMBER as VC27_34_, sysperson0_.VC_PHOTO$ID as VC28_34_, sysperson0_.N_SEQ as N29_34_, sysperson0_.VC_DEL$FLAG as VC30_34_, sysperson0_.VC_LOG$NAME as VC31_34_, sysperson0_.VC_DESC as VC32_34_, sysperson0_.VC_DEFAULT as VC33_34_, sysperson0_.VC_FILEID as VC34_34_ from SYS_T_PERSON sysperson0_ where (sysperson0_.VC_NUMBER='陈道全' or sysperson0_.VC_LOG$NAME='陈道全') and sysperson0_.VC_STATUS>0 and sysperson0_.VC_DEL$FLAG=0

























